﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using ZhiAo.WebLib.Data;

namespace ZhiAo.Management.Data
{
    public class GeneralData
    {
        public static DataTable GetData(string userId, string condition)
        {
            string sql = @"select g.* from dbo.GeneralReport g
                    inner join powerplat.dbo.SSO_ENTITY2FUNC e
                    on g.yr_stcd=e.functioncode
                    where e.entityid='{0}' {1}
                    order by g.shi,g.xian,g.sttp,g.stnm ";
            sql = string.Format(sql, userId, condition);
            return DBHelper.GetDataTable(sql);
        }
    }
}
